/**
 *温涛    
 */
package cn.edu.tyu.finance.thingstype.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import cn.edu.tyu.finance.thingstype.domain.Users;
import cn.edu.tyu.finance.util.DbUtil;

/**
 *
 * @author hujinyu
 * @version 1.0
 */
public class UserDaoImpl {
	public int addUser(Users users) throws SQLException {
		//获取数据库连接
		Connection conn = DbUtil.getConnection();
		//编写SQl语句
		String sql="insert into users values(?,?,?)";
		//获取语句执行者
		PreparedStatement ps = conn.prepareStatement(sql);
		//设置参数
		ps.setString(1, users.getUserid());
		ps.setString(2, users.getUsername());
		ps.setString(3, users.getUserpsw());
		//执行SQl语句,返回影响的行数
		int res = ps.executeUpdate();
		//释放数据库的连接
		DbUtil.backConn(conn, ps, null);
		return res;
	}
	//测试类
     public static void main(String[] args) throws SQLException {
    	 UserDaoImpl userDao=new UserDaoImpl();
    	 Users users=new Users();
    	 users.setUserid("1");
    	 users.setUsername("zs");
    	 users.setUserpsw("123456");
    	 userDao.addUser(users);
    	 int res= userDao.addUser(users);
    	 System.out.println("res="+res);
     }
}
